Read Cell Formula

AutomatR.DefaultActivities.WorkBook.ReadCellFormula

The "Read Cell Formula" activity in AutomatR is part of the WorkBook activities package, allowing you to extract the formula used in the specified Excel cell. This activity is designed to provide transparency into the formulas used in Excel cells, supporting data analysis and automation workflows.

Properties

Name	Description
Input
Cell	Specifies the cell number for which you need to read the Excel formula. String variables containing the cell number.
Excel File Path	Specifies the full path of the Excel workbook on the local drive, including the filename (e.g., "C:\excelActivities\workbook.xlsx"). String variables containing the Excel file path.
Password	Specifies the password for the workbook if required. Object variables containing the password.
Sheet Name	Specifies the name of the spreadsheet in which you want to perform the action. String variables containing the sheet name.
Misc
Display Name	Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name.
Optional
Delay	Specifies the amount of time (in seconds) to wait before executing the "Read Cell Formula" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 5 seconds, enter 5.
Output
Result	Returns the formula used in the specified Excel cell in string format. String variables to store the formula.

How to use:

1. Drag and drop the "Read Cell Formula" activity onto the workflow.
2. Specify the full path of the Excel workbook, including the filename.
3. Specify the name of the sheet from which to read the cell formula.
4. Specify the cell number for which you want to extract the formula.
5. Optionally, provide the password for the workbook if required.
6. Optionally, set the delay for the execution.
7. Execute the workflow to read the formula from the specified cell in the Excel spreadsheet.

Example:

Consider an example where the "Read Cell Formula" activity is used to extract the formula from cell "A1" in the "Sheet1" of an Excel workbook:

Read Cell Formula:
  Display Name: "Read Formula A1"
  Excel File Path: "C:\excelActivities\workbook.xlsx"
  Sheet Name: "Sheet1"
  Cell: "A1"
  Password: workbookPassword
  Result: cellFormula

In this example, the activity extracts the formula from cell "A1" in the "Sheet1" of the Excel workbook located at "C:\excelActivities\workbook.xlsx". If a password is required for the workbook, it is provided through the "workbookPassword" variable. The resulting formula is stored in the variable "cellFormula" for further use in the workflow.

Note: Ensure that the Excel file path, sheet name, and cell number are specified before executing this activity.